<%@ page pageEncoding="UTF-8" %>
<%@ page import="zth.*" %>
<%@ page import="zth.DBUtils" %>
<%@ page import="java.util.*" %>

<html>
<head>
	<meta http-equiv='Content-Type' content='text/html; charset=UTF-8' />
	<style>
	.menu {font-weight:bold; font-size:1em; padding:2em}
	tr {line-height:2.5em}
	 body
             {


             background-image:url(./upload/p8.jpg);
             background-repeat:no-repeat;

             background-color:pink;
             background-size:100%;
             }
       h1
       {
       margin-top:40px;
       }
       tr {
            line-height:2.5em;
            margin:0px;

            }
            td{
            margin:0px;
            }
        table
        {

           color:#426ab3;
            }
	</style>
</head>
<body>
	<div style='text-align:center;color:#f58220'><h1>摄影师信息合集！</h1></div>
	<div style='text-align:right;padding-right:3em'><a href='./logout'>退出</a></div>
</div>
	<center>
	<span>search:</span>
	<form action="./login" method="POST" class=".diyi">
	<input type='text' name='search' value='search'>
	</form>
	<table  border="1">

    	<tr style="color:blue">
    	    <td>id</td>
    	    <td>name</td>
    	    <td>sex</td>
    	    <td>tel</td>
    	    <td>qq</td>
    	    <td>describe</td>
            <td>addition</td>
    	 </tr>

<%
		String sql = "SELECT * FROM photoinf ORDER BY id DESC";
		List<photoinf> photoinfs = DBUtils.getphotoinf(sql);
		int lengthList=photoinfs.size();
		for(photoinf inf : photoinfs)
		 { out.println("<tr>");
	          out.println("<td>"+inf.getId()+"</td>"+"<td>"+inf.getName()+"</td>"+"<td>"+inf.getsex()+"</td>"+"<td>"+inf.getTel()+"</td>"+"<td>"+inf.getQq()+"</td>"+"<td>"+inf.getdescribe()+"</td>");



               		   out.println("</tr>");
		    }

	%>


</table>
	</center>
    </body>
</html>
